all code available here
There are a negligible number of cases at the county level where the state wasn’t known
There are relatively few cases at the county level that didn’t document age group
A lot of the death data is not documented at the county level. I think we should pull this information from a separate dataset.
some states didn’t list conf_death and conf_cases (cumulative counts), these were left empty
for analysis these were transformed to NA
only conf_death and conf_cases had NAs, rest of the variables (state, new_case, new_death, sub_date, time_interval) had complete information
There are states where for a month or several months, age group is not available (suppressed or missing)
For the most part, the distribution of cases over the age groups does not seem to vary a lot. As a result, for state:month combinations that we don’t have county case data on, it may be ok to use the distribution from the month before or after
| month | state | time_interval | case_tot | death_tot | age_group | prop | case_per_age |
|---|---|---|---|---|---|---|---|
| 5 | AK | 2021-05-31 | 408 | 4 | 0 - 17 years | 0.1770833 | 72 |
| 5 | AK | 2021-05-31 | 408 | 4 | 18 to 49 years | 0.5911458 | 241 |
| 5 | AK | 2021-05-31 | 408 | 4 | 50 to 64 years | 0.1901042 | 78 |
| 5 | AK | 2021-05-31 | 408 | 4 | 65+ years | 0.0416667 | 17 |
| 6 | AK | 2021-06-14 | 409 | 1 | 0 - 17 years | 0.1770833 | 72 |
| 6 | AK | 2021-06-14 | 409 | 1 | 18 to 49 years | 0.5911458 | 242 |
| 6 | AK | 2021-06-14 | 409 | 1 | 50 to 64 years | 0.1901042 | 78 |
| 6 | AK | 2021-06-14 | 409 | 1 | 65+ years | 0.0416667 | 17 |
| 6 | AK | 2021-06-28 | 625 | 5 | 0 - 17 years | 0.1770833 | 111 |
| 6 | AK | 2021-06-28 | 625 | 5 | 18 to 49 years | 0.5911458 | 369 |
| 6 | AK | 2021-06-28 | 625 | 5 | 50 to 64 years | 0.1901042 | 119 |
| 6 | AK | 2021-06-28 | 625 | 5 | 65+ years | 0.0416667 | 26 |
| 7 | AK | 2021-07-12 | 2210 | 5 | 0 - 17 years | 0.2067763 | 457 |
| 7 | AK | 2021-07-12 | 2210 | 5 | 18 to 49 years | 0.5386148 | 1190 |
| 7 | AK | 2021-07-12 | 2210 | 5 | 50 to 64 years | 0.1524664 | 337 |
| 7 | AK | 2021-07-12 | 2210 | 5 | 65+ years | 0.1021425 | 226 |
| 7 | AK | 2021-07-26 | 3677 | 13 | 0 - 17 years | 0.2067763 | 760 |
| 7 | AK | 2021-07-26 | 3677 | 13 | 18 to 49 years | 0.5386148 | 1980 |
| 7 | AK | 2021-07-26 | 3677 | 13 | 50 to 64 years | 0.1524664 | 561 |
| 7 | AK | 2021-07-26 | 3677 | 13 | 65+ years | 0.1021425 | 376 |